Adjust On Hand

Click to commit the changes and complete the adjustment.

Displays the History Summary report (also available via Inventory Reporting) for the part depending on the Facility selected.

Select the appropriate part number using the search box. This field will be grayed out if making an adjustment from the Inventory "Lots" or "Locations" reports since the Part and Lot will have already been selected.

Part number description. Populates after a part has been selected.

Defines the Master Lot name/description that is being adjusted. Read only

• Provides the ability to adjust out Master Lots using this transaction or via the "Adjust On hand" button on the Master Lot inventory report. This features allows companies to adjust master lots at once instead of the need to de-issue individual system lots first before performing adjustments on the de-issued lots. The security setting "Inventory -- adjust out master lots" controls access to this feature.

The stock pricing factor for the item being adjusted. Defined as the number of stock pricing units per stock unit.

• Example: Take an item that has a Unit Weight of "50" on the Calcs tab of the item, a Stock Unit of "Each" with a Factor of "1", and Stock Pricing Unit of "Pound" with a Factor of "1", the system will calculate the Stock Pricing Factor on this form as the item's Unit Weight (50) divided by the Stock Pricing Unit of Measure Factor (1). In this case the Stock Pricing Factor would be 50.

The stock pricing unit for the item being adjusted.

Displays the part's on hand quantity depending on the Facility, Location, or Lot selected on this form.

Read only. Stock Unit of the item being adjust based on the Stock Unit indicated on the Item Master record.

The part's value depending on the Facility, Location, or Lot selected on this form.

Read only. Currency is based on the Facility; if there is no Facility currency, the default system currency is used.

Pick list used to select how the transaction will change the part's quantity and value. Options are:

• Quantity and Value
• Value Only - Designed to work when running in Actual or Average cost modes only.

Defaults to today’s date, but may be changed.

Optional. When this field is set and inventory is getting adjusted into the system, the new lots will have lot dates equal to the lot date on this field.

• The expiration date will be derived from the lot date field, if the lot date field is populated, as [Lot Date + Shelf Days = Expires Date]. If it is not populated, it will be derived from date the "Transaction Date" as [Transaction Date = Shelf Days = Expires Date].
• For Value Only adjustments, the Lot Date will be read-only and blank.
• If adjusting from a Lots report, the Lot Date will be blank and set to the modified lot's lot date.

Search field used to select why the transaction is occurring. Reason Codes are maintained in Inventory > Maintenance > Reason Codes.

Search field used to select the Facility in which this transaction is occurring. If making adjustments from a Lots or Locations report, this field will be grayed out since the Facility has already been defined. 

Search field used to select the Location Type.

• When adjusting from the main menu, the system sets the Location Type and Location from the Item Master defaults.
• If the Item Master default Location Type is not in the Facility specified on this form, the Location Type is set to the default Location Type in that Facility instead and the Location is cleared.

Search field used to select the Location. 

Enter the amount to be adjusted.

The Unit of Measure for the Container that holds the selected part.

This will auto-fill when coming from a lots report.

Defines the unit cost of the lot, in the Currency specified, as a result of the adjustment. Specifically, the system checks the following items, in the order listed:

1. The most recent last cost of purchased or produced material in the Facility specified on this form.
   • Note: This Facility-specific Last Cost value is retained by the system, though it is not visible anywhere. Regardless of if there is a Facility Part Cross Reference, this form will use the Last Cost for the Facility selected.
2. If no purchased or produced inventory exists for the selected Facility, the "Acct. Std. Total" from the Facility Part Cross Reference is used (if one exists and its "Use Costs" flag is checked).
3. If no Facility Part Cross Reference exists, the "Acct. Std. Total" from the Item Master is used.

Example:

• Material is purchased in Facility 1 for Part 1 with a Cost of 1. This results in the Last Cost in the Item Master being 1.
• If Facility 1 is selected on the Adjust On Hand form, the Unit Cost will load as 1.
• Material is purchased in Facility 2 for Part 1 with a Cost of 2. This results in the Last Cost in the Item Master being 2.
• If Facility 1 is selected on the Adjust On Hand form, the Unit Cost will still load as 1 (even though this last cost of 1 is nowhere visible in the system).
• If Facility 2 is selected on the Adjust On Hand form, the Unit Cost will load as 2 (per the most recent purchase for that Part in that Facility).

Note: This field is always enabled when performing adjustments, including negative adjustments.

Defines the user lot that will be created as a result of the adjustment.

• If making adjustments from the Inventory "Lots" or "Locations" reports, this field will be grayed out since the Facility has already been defined.
• If the Part requires that users specify a lot number, this field will display the words "Lot required".
• If the item does not require users to specify a lot number this field will display the word "System".
• The security setting "Inventory - edit user lot when adjusting inventory" controls if the "User Lot" field is disabled when adjusting in inventory.

Defines the system lot that will be created as a result of the adjustment.

• If making adjustments from the Inventory "Lots" or "Locations" reports, this field is grayed out since the system lot was defined previously. In these cases, the system checks to verify the specified system lot does in fact exist and that it uses the same part number as the one being adjusted.
• When populating this field, the Expiration Date and Lot Date will be derived from the "Lot Date" field, if it is populated, as [Lot Date + Shelf Days = Expires Date]. If it is not populated, it will be derived from date the "Transaction Date" as [Transaction Date = Shelf Days = Expires Date].

Expiration date for the item lot selected on the form. The different calculations used by the system to calculate this date are as follows:

• Adjusting from the main menu and selected item has no Shelf Life - the Expiration date will be blank
• Adjusting from the main menu and selected item has a Shelf Life - the Expiration date will be the transaction date + Shelf Life days as defined on the "General 2" tab of the Item Master.
• Adjusting from the "Lots" report via Inventory > Item Master - the Expiration date will be the Expiration date of the lot selected.

Notes:

1. This field is required (marked in blue) if the item selected has the "Require Expiration Date" flag checked.

2. Changing the transaction date causes the expiration date to be recalculated when adjusting from the main menu.

30 character text fields available for company-specific lot and inventory information. The captions for these fields is maintained in Captions.

Option to enter the actual density of the lots when using the Produce Assemblies transaction. The ability to enter values in this field is controlled by the "Measured Density" flag on the Item Master Properties tab.

The inventory account as defined on Item Master Accounts tab.

• The security setting "Inventory -- adjust on hand inventory account" controls access to this field.
• If making adjustments from the Inventory "Lots" or "Locations" reports, this field will be grayed out.
• In WMS, the account on the item master will be used by default, and an error will be displayed if there is no applicable account. User cannot change via WMS.

Expense account to which inventory adjustments are debited. The default for this field will be supplied by either the "Inventory Adjustment" account specified on the "Reason Code" selected, or, if the Reason Code does not contain an account, the item's "Inventory Adjustment" account. If both the reason code and item do not contain an account, it will keep what is currently selected. The default may be overridden if necessary.

• The security setting "Inventory -- override adj account" controls access to this field.
• In WMS, the adjustment account of the item will be used by default, and an error will be displayed if there is no applicable account. User cannot change via WMS.

Attempts to adjust in or out the quantities specified.

• If the user chooses a transaction date in the past, they will require security setting "Accounting -- backdate transactions".
• If an item requires an expiration date, it must be entered or changes will not be applied.
• If the user attempts to adjust a lot with quarantined items, they will require security setting "Inventory -- adjust onhand from quarantine".

The user will be sent back to the main WMS menu.